Stock reports

Shows the quantity and value of sales per stock item per calendar month.

These are additionally grouped and totalled depending on the report selected.

Shows the number of items required to fulfil outstanding sales orders. The free stock, reorder level and required quantities are shown.

It also shows which items you need to re-order, based on your re-order levels. This can be shown in two ways:

• Based on the number of items in stock, both allocated and unallocated. This is the default.
• Based on your free stock levels, unallocated only. Select Free stock against re-order level in the criteria.

This shows all the cost prices for the items you have in stock and number of items bought at that price.

Note: Items with a negative stock level aren't shown.

Shows the value of your stock. This is the current stock level multiplied by the cost price.

The cost price is calculated differently depending the costing method of the stock item. See Stock valuation.

Shows all the stock items that need re-ordering - i.e. fallen below their re-order level. Stock items are grouped by warehouse and product group.

You can choose whether to include all items or only those that need re-ordering.

Note: Only items which have a re-order level set are shown. i.e. the re-order level at least one warehouse is more than 0.00.

There are two versions of the report:

• Alternatives - shows you any alternative items set for the item.
• Suppliers - shows you any preferred supplier set for the item.

Shows you the total profit you've made from the sale of individual stock items. Two profit figures are show; this period and last period.

The value of the sale and purchase of stock items is accumulated by Sage 200, and shows as your This period figure. You can choose to change it manually, using the Reset Trading Periods screen. Once you do this the value bought and sold this period is added to the Last period figures, and the This period figure is reset to 0.

Shows you a list of all stock items, arranged by product group.

Also displays the unit, stocktake cycle and manufacturer details.

Shows a list of stock item analysis codes and their values.

It only includes analysis codes where you have changed the label. Analysis codes with the default label of Analysis Code 1 and so on, are not included.

Prints a bar code label for each stock item with a bar code specified.

This prints using Format 39 barcodes by default. You can change this in Report Designer if required.

See How to set up and print labels

Use this report to view stock items that have associated cross-selling items. The report lists individual stock items with their cross-selling items.

See Cross-selling stock items.

Shows you a list of all stock movements per stock item.

This can also be seen on the Stock History Enquiry screen.

There are two versions:

• Detailed - shows you all movements and adjustments.
• Simple - just shows you the actual stock movements.

Shows you all items due for a stock take based on the Intended stocktake date entered on the criteria.

Use this to help you plan when you need to do a stocktake.

Note: This can only be calculated for items that have a stock take cycle specified on the stock record.

Shows all items that are components of a BOM and which BOM(s) they're included in.

This report is sorted by product group and then by item.